﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_GetTerminal')
	BEGIN
		DROP  Procedure  esf_sso.P_GetTerminal
	END
GO

CREATE Procedure esf_sso.P_GetTerminal
	@pTerminalCode		VARCHAR (100)
AS

	SELECT
		*
	FROM
		esf_sso.VTerminal VT
	WHERE
		VT.Code = @pTerminalCode
		
GO